SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Great house! Great Location! And Energy Efficient to boot! This sun drenched contemporary raised ranch makes living in the Upper Valley simple and easy. The thoughtfully designed interior offers an option of one floor living that capitalizes on the bank of western facing windows capturing not only the warmth of the sun but also stunning lake and mountain views. The home is turnkey and ready to move into with a beautifully renovated open kitchen/ dining /living area outfitted with new appliances and new windows, as well as, 2 generous bedrooms, an office, and full bath and laundry all on the main level. The lower level is complete with a bright and airy family room with Woodstock Soapstone wood stove, a bonus/bedroom, full bath, workshop and plenty of storage. This floor walks directly out to your own private oasis of lovely gardens, prolific blueberry bushes and views of Mascoma Lake. Additionally, the home includes an oversized 2 car garage with EV plug, 2 decks and is equipped with new central AC and solar panels installed on the roof with net metered electricity providing maximum energy efficiency.. The property can be purchased alone or in combination with the lakefront camp across the road providing for a wonderful year round lakefront experience. Open House Sat 4/12 9-11 and Sun 4/13 11-1
Description:Classic West Lebanon new englander in great location! This house has SO much to offer! Great spaces - including eat-in kitchen, playroom with slider to the deck and renovated 3/4 bathroom, den and formal living room combination. Upstairs you will find 3-4 bedrooms and a renovated full bathroom including a gorgeous primary bedroom with new wood floors and walk in closet. Attic is finished and would be great for a playroom, office or guest bedroom. House has had lots of updates - new roof, renovated laundry room, newer appliances, refinished wood floors, newly paved driveway - and more! Showings start with Open House Saturday, April 5th 10:00-12:30 and Sunday, April 6th 1:00-3:30.